Hệ thống quản lý bệnh viện bằng C# với mã nguồn

1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="hospitalDataSet" targetNamespace="http://tempuri.org/hospitalDataSet.xsd" xmlns:mstns="http://tempuri.org/hospitalDataSet.xsd" xmlns="http://tempuri.org/hospitalDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3   <xs:annotation>
4     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6         <Connections>
7           <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="hospitalConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="hospitalConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HospitalManagementSystemCSharp.Properties.Settings.GlobalReference.Default.hospitalConnectionString" Provider="System.Data.SqlClient" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="staffTableAdapter" GeneratorDataComponentClassName="staffTableAdapter" Name="staff" UserDataComponentName="staffTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef="hospitalConnectionString (Settings)" DbObjectName="dbo.staff" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13                 <DeleteCommand>
14                   <DbCommand CommandType="Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM [dbo].[staff] WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gender = 1 AND [gender] IS NULL) OR ([gender] = @Original_gender)) AND ((@IsNull_position = 1 AND [position] IS NULL) OR ([position] = @Original_position)) AND ((@IsNull_salary = 1 AND [salary] IS NULL) OR ([salary] = @Original_salary)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
19                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
20                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="true" SourceVersion="Original" />
21                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_position" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_position" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_salary" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="salary" SourceColumnNullMapping="true" SourceVersion="Original" />
25                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_salary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="salary" SourceColumnNullMapping="false" SourceVersion="Original" />
26                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_contact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="true" SourceVersion="Original" />
27                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Original" />
28                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="true" SourceVersion="Original" />
29                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Original" />
30                     </Parameters>
31                   </DbCommand>
32                 </DeleteCommand>
33                 <InsertCommand>
34                   <DbCommand CommandType="Text" ModifiedByUser="false">
35                     <CommandText>INSERT INTO [dbo].[staff] ([name], [gender], [position], [salary], [contact], [address]) VALUES (@name, @gender, @position, @salary, @contact, @address);
36 SELECT Id, name, gender, position, salary, contact, address FROM staff WHERE (Id = SCOPE_IDENTITY())</CommandText>
37                     <Parameters>
38                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
39                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Current" />
40                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@position" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Current" />
41                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@salary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="salary" SourceColumnNullMapping="false" SourceVersion="Current" />
42                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Current" />
43                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
44                     </Parameters>
45                   </DbCommand>
46                 </InsertCommand>
47                 <SelectCommand>
48                   <DbCommand CommandType="Text" ModifiedByUser="false">
49                     <CommandText>SELECT Id, name, gender, position, salary, contact, address FROM dbo.staff</CommandText>
50                     <Parameters />
51                   </DbCommand>
52                 </SelectCommand>
53                 <UpdateCommand>
54                   <DbCommand CommandType="Text" ModifiedByUser="false">
55                     <CommandText>UPDATE [dbo].[staff] SET [name] = @name, [gender] = @gender, [position] = @position, [salary] = @salary, [contact] = @contact, [address] = @address WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gender = 1 AND [gender] IS NULL) OR ([gender] = @Original_gender)) AND ((@IsNull_position = 1 AND [position] IS NULL) OR ([position] = @Original_position)) AND ((@IsNull_salary = 1 AND [salary] IS NULL) OR ([salary] = @Original_salary)) AND ((@IsNull_contact = 1 AND [contact] IS NULL) OR ([contact] = @Original_contact)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)));
56 SELECT Id, name, gender, position, salary, contact, address FROM staff WHERE (Id = @Id)</CommandText>
57                     <Parameters>
58                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
59                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Current" />
60                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@position" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Current" />
61                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@salary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="salary" SourceColumnNullMapping="false" SourceVersion="Current" />
62                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Current" />
63                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
64                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
65                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
66                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
67                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="true" SourceVersion="Original" />
68                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Original" />
69                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_position" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="true" SourceVersion="Original" />
70                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_position" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="position" SourceColumnNullMapping="false" SourceVersion="Original" />
71                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_salary" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="salary" SourceColumnNullMapping="true" SourceVersion="Original" />
72                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_salary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="salary" SourceColumnNullMapping="false" SourceVersion="Original" />
73                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_contact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="true" SourceVersion="Original" />
74                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_contact" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contact" SourceColumnNullMapping="false" SourceVersion="Original" />
75                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="true" SourceVersion="Original" />
76                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Original" />
77                       <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[F:\Sem.4\C# Projects\Trials\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\HOSPITAL.MDF].dbo.staff" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
78                     </Parameters>
79                   </DbCommand>
80                 </UpdateCommand>
81               </DbSource>
82             </MainSource>
83             <Mappings>
84               <Mapping SourceColumn="Id" DataSetColumn="Id" />
85               <Mapping SourceColumn="name" DataSetColumn="name" />
86               <Mapping SourceColumn="gender" DataSetColumn="gender" />
87               <Mapping SourceColumn="position" DataSetColumn="position" />
88               <Mapping SourceColumn="salary" DataSetColumn="salary" />
89               <Mapping SourceColumn="contact" DataSetColumn="contact" />
90               <Mapping SourceColumn="address" DataSetColumn="address" />
91             </Mappings>
92             <Sources />
93           </TableAdapter>
94         </Tables>
95         <Sources />
96       </DataSource>
97     </xs:appinfo>
98   </xs:annotation>
99   <xs:element name="hospitalDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="hospitalDataSet" msprop:Generator_UserDSName="hospitalDataSet">
100     <xs:complexType>
101       <xs:choice minOccurs="0" maxOccurs="unbounded">
102         <xs:element name="staff" msprop:Generator_TableClassName="staffDataTable" msprop:Generator_TableVarName="tablestaff" msprop:Generator_TablePropName="staff" msprop:Generator_RowDeletingName="staffRowDeleting" msprop:Generator_RowChangingName="staffRowChanging" msprop:Generator_RowEvHandlerName="staffRowChangeEventHandler" msprop:Generator_RowDeletedName="staffRowDeleted" msprop:Generator_UserTableName="staff" msprop:Generator_RowChangedName="staffRowChanged" msprop:Generator_RowEvArgName="staffRowChangeEvent" msprop:Generator_RowClassName="staffRow">
103           <xs:complexType>
104             <xs:sequence>
105               <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
106               <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
107                 <xs:simpleType>
108                   <xs:restriction base="xs:string">
109                     <xs:maxLength value="50" />
110                   </xs:restriction>
111                 </xs:simpleType>
112               </xs:element>
113               <xs:element name="gender" msprop:Generator_ColumnVarNameInTable="columngender" msprop:Generator_ColumnPropNameInRow="gender" msprop:Generator_ColumnPropNameInTable="genderColumn" msprop:Generator_UserColumnName="gender" minOccurs="0">
114                 <xs:simpleType>
115                   <xs:restriction base="xs:string">
116                     <xs:maxLength value="50" />
117                   </xs:restriction>
118                 </xs:simpleType>
119               </xs:element>
120               <xs:element name="position" msprop:Generator_ColumnVarNameInTable="columnposition" msprop:Generator_ColumnPropNameInRow="position" msprop:Generator_ColumnPropNameInTable="positionColumn" msprop:Generator_UserColumnName="position" minOccurs="0">
121                 <xs:simpleType>
122                   <xs:restriction base="xs:string">
123                     <xs:maxLength value="50" />
124                   </xs:restriction>
125                 </xs:simpleType>
126               </xs:element>
127               <xs:element name="salary" msprop:Generator_ColumnVarNameInTable="columnsalary" msprop:Generator_ColumnPropNameInRow="salary" msprop:Generator_ColumnPropNameInTable="salaryColumn" msprop:Generator_UserColumnName="salary" minOccurs="0">
128                 <xs:simpleType>
129                   <xs:restriction base="xs:string">
130                     <xs:maxLength value="50" />
131                   </xs:restriction>
132                 </xs:simpleType>
133               </xs:element>
134               <xs:element name="contact" msprop:Generator_ColumnVarNameInTable="columncontact" msprop:Generator_ColumnPropNameInRow="contact" msprop:Generator_ColumnPropNameInTable="contactColumn" msprop:Generator_UserColumnName="contact" minOccurs="0">
135                 <xs:simpleType>
136                   <xs:restriction base="xs:string">
137                     <xs:maxLength value="50" />
138                   </xs:restriction>
139                 </xs:simpleType>
140               </xs:element>
141               <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address" minOccurs="0">
142                 <xs:simpleType>
143                   <xs:restriction base="xs:string">
144                     <xs:maxLength value="50" />
145                   </xs:restriction>
146                 </xs:simpleType>
147               </xs:element>
148             </xs:sequence>
149           </xs:complexType>
150         </xs:element>
151       </xs:choice>
152     </xs:complexType>
153     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
154       <xs:selector xpath=".//mstns:staff" />
155       <xs:field xpath="mstns:Id" />
156     </xs:unique>
157   </xs:element>
158 </xs:schema>


Web, Tìm kết quả nhanh

Hệ thống quản lý bệnh viện


Kích thước hoặc độ phức tạp của bản gửi này, tác giả đã gửi nó dưới dạng tệp .zip để rút ngắn thời gian tải xuống của bạn. Sau khi tải xuống, bạn sẽ cần một chương trình như Winzip để giải nén nó.

Tất cả các tệp đều được codefly.vn quét mỗi ngày một lần để tìm vi-rút, nhưng vi-rút mới xuất hiện hàng ngày nên không có chương trình phòng ngừa nào có thể bắt được 100% chúng.

ĐỂ AN TOÀN CỦA CHÍNH BẠN, VUI LÒNG:

1. Quét lại các tệp đã tải xuống bằng trình kiểm tra vi-rút cá nhân của bạn trước khi sử dụng.

2. KHÔNG BAO GIỜ, chạy các tệp đã biên dịch (.exe's, .ocx's, .dll's, v.v.)--chỉ chạy code mà bạn đã xem ít nhất 1 lần.

Official Website:

https://code-projects.org/.....with-source-code-2/

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

93 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

99 lượt xem

Đếm nguyên âm và phụ âm

135 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

211 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

168 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

185 lượt xem